CREATE VIEW [dbo].[vw_EpoTracking]
AS
SELECT        dbo.EPOTracking.Id, dbo.EPOTracking.OrderId, dbo.EPOTracking.NationalCode, dbo.EPOTracking.Mobile, dbo.EPOTracking.TrackingCode, dbo.EPOTracking.InsuranceType, dbo.EPOTracking.SupplemetaryName, 
                         dbo.EPOTracking.CreatedOn, dbo.EPOTracking.Description, dbo.EPOTracking.OrderDate, dbo.EPOTracking.DeliveryDateInfo, dbo.EPOTracking.Status, dbo.EPOTracking.QueueNumber, dbo.EPOTracking.IsPaid, 
                         dbo.EPOTracking.PrescriptionId, dbo.EPOTracking.UpdatedOn, dbo.EPOTracking.FullName, EpoD.DescriptionDetails, dbo.EPOTracking.OrderJson
FROM            dbo.EPOTracking WITH (nolock) LEFT OUTER JOIN
                             (SELECT        TrackingId, Description AS DescriptionDetails
                                FROM            dbo.EPOTrackingDetail WITH (nolock)
                                WHERE        (Status = 40) AND (Description IS NOT NULL)
                                GROUP BY Description, TrackingId) AS EpoD ON EpoD.TrackingId = dbo.EPOTracking.Id
